deallocate prepare

SQL/PL

Deallocate a previously prepared statement

Syntax

deallocate_stmt:
          DEALLOCATE PREPARE stmt_name

Description

The DEALLOCATE PREPARE statement disavows all knowledge of the SQL statement associated with stmt_name as assigned by its previously executed PREPARE statement.

Example

set stmtstr = "SELECT * FROM ACCTMGR WHERE mgrid = '" || newId || "'";
prepare s2 from stmtstr;
execute s2 into c_id, c_name, c_hired, c_commission;
select stat, c_id, c_name, c_hired, c_commission;
deallocate prepare s2;